1. Tables These are the building blocks or relation of any relational database model where all the actual data is defined and entered. Different types of operation are done on the tables such as storing, filtering, retrieving and editing of data. Tables consist of cells at the intersection of records (rows)) and fields (columns).

.... (More Text Available, Login?)

Sample Questions

(More Questions for each concept available in Login)

Question : 1

The database object that is used to extract information from the database, is _______________
A. Query		B. Table
C. Report		D. Form
Right Option : A
View Explanation

Question : 2

Which of the following places the common data elements in order from smallest to largest ?
A. Charater, File, Record, Field, Database	B. Character, Record, Field, File, Database	C. Character, Field, Record, File, Database	D. Bit, Byte, Character, Record, Field, File, Database
Right Option : C
View Explanation

Explanation

Components of a Database

A database consists of several different components. Each component listed, is called an object. Bit (Character) - a bit is the smallest unit of data representation (value of a bit may be a 0 or 1). Eight bits make a byte which can represent a character or a special symbol in a character code. Database components are described below

(i) Field a field consists of a grouping of characters. It is an area (within the record) reserved for a specific piece of data. e.g. Customer number, customer name, street address, city, state, phone number, current address etc. Field of a table is also known as column.

(ii) Record It is the collection of data items of all the fields pertaining to one entity, i.e. a person, company, transition, etc. Record of a table is also known as row or a tuple and the number of records in a relation is called the cardinality of that relation.

(iii) File: A file is a collection of records.

2. Queries: These are basically questions based on the data available in a database. A query consists of specifications indicating which fields, records and summaries a user wants to fetch from a database. Queries allow you to extract data based on the criteria that you define.

3. Forms; Although you can enter and modify data in datasheet view of tables but you neither control the user's action very well nor you can do much to facilitate the data - entry process. To overcome this problem, forms are introduced.

Like tables, forms can be used to view and edit your data. However, forms are typically used to view the data in an underlying table one record at a time.

E.g. A user can create a data entry form that looks exactly like a paper form. People generally prefer to enter data into a well-designed form, rather than a table.

4. Reports When you want to print those records which are fetched from your database, design a report. Access even has a wizard to help produce mailing labels.

In the Question:

Which of the following places the common data elements in order from smallest to largest ?

The Answer is Character, Field, Record, File, Database. Character, field, record, file, database are the common data elements in order from smallest to largest.

Hence the Option C is Correct.

Question : 3

A _________ is a collection of data that is stored electronically as series of records in a table.
A. Spreadsheet	B. Presentation	C. Database	D. Web page
Right Option : C
View Explanation

Why ABHYAS?

Self Learning

Course Benefits

Our Areas of Expertise

IMO-Mathematics Olympiad

Central Government Service

ISO - Science Olympiads

State Government Services

Banking And Insurance

MBA Entrance

Law Entrance

English Proficiency

Reasoning Proficiency

Computer Proficiency

Navodaya Entrance 6th & 9th

Sainik School Entrance

Andhra Bank

Students / Parents Reviews [10]

About Abhyas metholodology the teachers are very nice and hardworking toward students.The Centre Head Mrs Anu Sethi is also a brilliant teacher.Abhyas has taught me how to overcome problems and has...

Shreya Shrivastava

8th

It was good as the experience because as we had come here we had been improved in a such envirnment created here.Extra is taught which is beneficial for future.

Eshan Arora

8th

It has a great methodology. Students here can get analysis to their test quickly.We can learn easily through PPTs and the testing methods are good. We know that where we have to practice

Barkha Arora

10th

It was a good experience with Abhyas Academy. I even faced problems in starting but slowly and steadily overcomed. Especially reasoning classes helped me a lot.

Cheshta

10th

One of the best institutes to develope a child interest in studies.Provides SST and English knowledge also unlike other institutes. Teachers are co operative and friendly online tests andPPT develo...

Aman Kumar Shrivastava

10th

My experience with Abhyas is very good. I have learnt many things here like vedic maths and reasoning also. Teachers here first take our doubts and then there are assignments to verify our weak poi...

Shivam Rana

7th

I have spent a wonderful time in Abhyas academy. It has made my reasoning more apt, English more stronger and Maths an interesting subject for me. It has given me a habbit of self studying

Yatharthi Sharma

10th

Abhyas is a complete education Institute. Here extreme care is taken by teacher with the help of regular exam. Extra classes also conducted by the institute, if the student is weak.

Om Umang

10th

Being a parent, I saw my daughter improvement in her studies by seeing a good result in all day to day compititive exam TMO, NSO, IEO etc and as well as studies. I have got a fruitful result from m...

Prisha Gupta

8th

Abhyas Methodology is very good. It is based on according to student and each child manages accordingly to its properly. Methodology has improved the abilities of students to shine them in future.

Manish Kumar

10th

View All

Attention !!!!!

Components Of Database

Components of a Database

Components of a Database

Students / Parents Reviews [10]

Shreya Shrivastava

Eshan Arora

Barkha Arora

Cheshta

Aman Kumar Shrivastava

Shivam Rana

Yatharthi Sharma

Om Umang

Prisha Gupta

Manish Kumar